DATA ENGINEER
At Commercial Alliance, we rely on powerful insightful data to inform our process and delivery of financial products to our customers. The Data Engineer plays a critical role by designing, developing, testing, and maintaining data centric applications that meet user needs and business objectives, working closely with cross-functional teams to deliver high quality, scalable, and efficient solutions. This role will include responsibilities from data onboarding, ETL process maintenance, to development of dashboards and analytical tools.
ESSENTIAL DUTIES AND RESPONSIBILITIES:
- Design, develop, and maintain data pipelines according to project requirements.
- Create custom python-based code to collect or manipulate data to be consumed by other analytics systems.
- Collaborate with designers, product managers, and other developers to define and implement technical solutions.
- Build and partner to optimize data architectures and data models.
- Integrate data from multiple sources into centralized data warehouses or data lakes.
- Ensure data quality, consistency, and integrity across systems
- Contribute to the automation of data processing and deployment pipelines.
- Debug, test, and fix issues to ensure software reliability and performance.
- Stay up to date with emerging technologies and industry’s best practices.
- Maintain vendor performance metrics and assist in evaluating contract effectiveness and service-level adherence.
QUALIFICATIONS:
Required:
- Three or more years of experience with Python, SQL, and data visualization/exploration tools
- Familiarity with the Azure ecosystem.
- Proficiency in one or more programming languages (e.g., JavaScript, Python, TypeScript, Go).
- Understanding of API connectivity (e.g. REST, GraphQL, SOAP).
- Linux (or access to Linux support) for any on-prem (hybrid) components
- Understanding of structured data formats (JSON, XML, CSV)
- Proficient in SQL syntax and query development.
- Understanding of databases (SQL and/or NoSQL, KQL, CQK, SPL).
- Experience with Medallion data warehousing or other data architectures.
- Understanding of data modeling and schematic creation.
- Familiarity with version control systems (e.g., Git, GitHub).
- Understanding of cloud storage (AWS, GCP, Azure Blob)
- Excellent communication and teamwork abilities.
Preferred:
- Experience with Tines or similar automation platform
- Experience with Cribl Stream, Edge, and Search or similar data pipeline/collection platform
- Experience with Snowflake or similar data warehouse/RDBMS platform
EDUCATION & EXPERIENCE
Education: Bachelor’s degree in computer science, Software Engineering, or a related field. Professional Certifications accepted in lieu of bachelor's degree.
Experience: Two years of data engineering experience or other related field
Commercial Alliance offers exciting and challenging opportunities to work in a dynamic, collaborative, and innovative environment.. As a part of our team you'll enjoy our competitive salary and benefits packages. You'll also encounter exciting opportunities for both professional and personal growth, along with recognition and valuable experiences.
If you are a strategic thinker with a passion for delivering exceptional products and working in a fast-paced environment, we would love to hear from you. Apply today to join our team!
