Data Engineer

Genesis10 is seeking a Data Engineer for our client in the Financial Services Industry. This is a Full Time / Perm position located in Plano, TX. 75038

Job Description

The role of Data Engineer is to design, develop, and support database solutions using Microsoft SQL Server and Snowflake. This person works to gain an understanding of the business objectives when defining technical requirements within time and budget constraints.

Key Responsibilities :

• Design and implementation of complex Operational Data Store, Data warehouse, and Data mart design patterns (star schema, snowflake schema, entity relationship, and dimensional data models)
• Design, implement, and maintain data pipelines using Snowflake, DBT, and Apache Airflow
• Analyze user requirements to Design, Develop and optimize ETL / ELT processes for data ingestion, transformation, and loading
• Collaborate with data modelers to implement and maintain data models in Snowflake
• Write and maintain DBT models for data transformation and business logic implementation
• Work with management and infrastructure teams as an influencer of decision to use open source or cloud managed services for DBT and Airflow
• Work with product owners and other development team members to determine new features, user stories, and requirements needed to create or revise database components such as : Tables, views, stored procedures, SSIS packages, triggers, functions, pipelines, models, etc.
• Create or Update documentation in support of development efforts. Documents may include detailed specifications, implementation guides, architecture diagrams or design documents
• Participate in code reviews with peers and managers to ensure that each delivery adheres to original vision as described in the user story / business requirements and adherence to standard resource libraries and architecture guidelines
• Ensure data quality, consistency, and integrity throughout the data lifecycle
• Implement data security and access control measures in Snowflake
• Optimize query performance and resource utilization in Snowflake
• Collaborate with other teams to integrate data systems and support analytics needs
• Implement data governance policies and best practices
• Create table indexing and query strategies, database objects maintenance, and troubleshoot performance issues
• Understand the company's key data and / or systems architectures, including how these systems fit within the overall business
• Troubleshoot and resolve data pipeline issues
• Mentor less experienced technical staff

Required Qualifications :

Preferred Qualifications :

Key Skills :

If you have the qualifications described and are interested in this exciting opportunity, please apply as soon as possible!

Ranked a Top Staffing Firm in the U.S. by Staffing Industry Analysts for six consecutive years, Genesis10 puts thousands of consultants and employees to work across the United States every year-in contract, contract-for-hire, and permanent placement roles. With more than 300 active clients, Genesis10 provides access to many of the Fortune 100 firms and a variety of mid-market organizations across the full spectrum of industry verticals.

Benefits of Working with Genesis10 :

For multiple years running, Genesis10 has been recognized as a Top Staffing Firm in the U.S., as a Best Company for Work-Life Balance, as a Best Company for Career Growth, for Diversity, and for Leadership, amongst others. To learn more and to view all our available career opportunities, please visit us on our website.

Genesis10 is an Equal Opportunity Employer. Candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.