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:

• Bachelor's degree in computer science, Information Systems, or related field
• 5+ years of experience in data engineering, with a strong focus on data warehouse and data mart architecture.
• Strong proficiency in writing SQL
• Proficient in reading/writing Python
• Hands-on experience with MS SQL Server, Snowflake, DBT, and Apache Airflow
• Experience with cloud-based data warehousing and ETL/ELT processes
• Knowledge of data modeling concepts and best practices
• Understanding of data privacy and security principles

Preferred Qualifications:

• Experience in the financial or mortgage industry
• Experience with Object Oriented designs, middleware architectures, distributed computing solutions and API design best practices.
• Experience with Reporting and Visualization tools such as SSRS and Power BI.

Key Skills:

• Strong analytical and problem-solving abilities
• Excellent coding practices and documentation skills
• Ability to work in a fast-paced, collaborative environment
• Effective communication skills to interact with both technical and non-technical stakeholders
• Proactive approach to identifying and resolving data issues

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:

• Access to hundreds of clients, most who have been working with Genesis10 for 5-20+ years.
• The opportunity to have a career home with Genesis10; many of our consultants have been working exclusively with Genesis10 for years. Access to an experienced, caring recruiting team (more than 7 years of experience, on average.)
• Behavioral Health Platform
• Medical, Dental, Vision
• Health Savings Account
• Voluntary Hospital Indemnity (Critical Illness & Accident)
• Voluntary Term Life Insurance
• 401K
• Sick Pay (for applicable states/municipalities)
• Commuter Benefits (Dallas, NYC, SF)
• Remote opportunities available

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.