Senior Data Engineer

Data Ideology

At DI, we provide Data & Analytics expertise to drive measurable business outcomes, often solving complex business problems for our clients. Our data analytics advisory services enable our customers to transform data into insights by driving a culture of empowerment and ownership of results. Our team consists of highly motivated individuals passionate about learning, understanding, collaborating, and intellectually curious.  For more information about Data Ideology, visit www.dataideology.com 

Senior Data Engineer - Full-time

We are looking for a Sr. Data Engineer to join our growing team. Sr. Data Engineer will leverage their business and technical knowledge to develop production-ready data models by integrating multiple data sources while working with business and technical teams to understand business strategy and objectives, gather information, and ensure business requirements are being fulfilled throughout the entire data & analytics lifecycle.

Key Responsibilities

To perform in this position successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions. Other duties may be assigned to meet business needs.

• Design, build, and optimize ETL/ELT workflows using SSIS for various data integration needs
• Develop and maintain T-SQL scripts, stored procedures, and functions within SQL Server to support data movement and transformation
• Collaborate with data architects and analysts to design and implement data warehouse solutions using dimensional modeling best practices
• Support and enhance data solutions aligned with the medallion architecture (bronze, silver, gold layer concepts)
• Monitor, troubleshoot, and optimize performance of SSIS packages and SQL queries
• Ability to collect and understand business requirements and translate those requirements into an actionable data warehouse plan.
• Ability to work within the SDLC framework in multiple environments and understand the complexities and dependencies of the data warehouse built within those constraints.

Supervisory Responsibilities: None

Qualifications

Education and Experience:

• 5+ years of professional experience in a Data Engineering or ETL Developer role
• Hands-on experience developing and deploying SSIS packages
• Proven experience working in a data warehouse environment, particularly with dimensional modeling (star/snowflake schemas)
• Familiarity with data pipeline design aligned to medallion architecture or similar layered data lake approaches
• Knowledge of data governance, data quality, and data cataloging practices
• API integration experience is a plus

Knowledge, Skills, and Abilities:

• BI/Data Warehousing (5+ years) 
• Ability to work independently and collaboratively in a fast-paced environment
• Strong analytical, troubleshooting, and communication skills
• Banking experience a plus
• Consulting experience a plus

Work Environment: 

• Remote work from home. 
• Hours of work and days are generally Monday through Friday. Specific business hours will depend on client needs. 

Physical Demands: 

• Must be able to remain in a stationary position 50% of the time. 
• The person in this position must occasionally move about inside the office to access file cabinets, library stacks, office machinery, etc. 
• Constantly operates a computer and other office productivity machinery, such as a calculator, copy machine, and printer. 
• The person in this position frequently communicates with clients and coworkers. Must be able to exchange accurate information in these situations. 

Benefits:   

• Flexible Time Off Policy
• Eligibility for Health Benefits
• Retirement Plan with Company Match
• Training and Certification Reimbursement
• Utilization Based Incentive Program
• Commission Incentive Program
• Referral Bonuses
• Work from Home

Data Ideology is an EEO Employer