What are the responsibilities and job description for the Sr. Database Engineer position at The Intersect Group?
Sr. Database Engineer
POSTED : January 22, 2025 LOCATION : Dallas TX POSITION ID : #247389 EMPLOYMENT TYPE : Direct Hire Salary : $115000
Location : Dallas, TX
Type : Direct Hire
Job #247389
Salary : $115,000
SR. DATABASE DEVELOPER
ROLE AND RESPONSIBILITIES
The Intersect Group is seeking a Sr. Database Developer for our direct healthcare client, where you will be responsible for designing and building databases / data warehouses to store and manage healthcare claims and financial data. This position will analyze data, develop, test, and implement processes to load it, and assist with reporting. This person will have a strong understanding of RDBMS / Data Warehouse concepts, along with knowledge of claims or financial data.
PRIMARY DUTIES
Analyze Healthcare data, architect and design data models, and create databases / data warehouses
Design and develop ETL processes necessary to load this data to the Enterprise Data Warehouse (EDW)
Implement, schedule, monitor and support all related processes, applications and databases
Build indexes and fine tune queries to ensure performance needs are met
Collaborate closely with reporting team to create data mart to support reporting and analysis needs
Perform advanced data analysis, identify issues and data gaps, and help provides insights
Implement and support Master Data Management processes
Ensure flexibility, scalability, consistency and quality when build solutions
Follow best practices for development, QA, deployment, source code management
Manage source code, conduct code reviews, and test
Monitor and support processes / jobs, and follow up on issues.
Coordinate closely with other developers to streamline processes and optimize
Gain strong knowledge of underlying data and business rules, and assist other teams
Adopt agile methodology, and assist in tracking and communicating progress of deliverables
REQUIREMENTS :
Bachelor’s degree in Computer Science or equivalent combinations of education and experience
6 years’ experience in designing / modeling, and building data warehouses and data marts
6 years' experience building database objects in SQL Server : complex queries, stored procedures, tables, views, functions, indexes, etc.
2 years’ experience working with Healthcare claims (835 / 837 files) or Financial data
Demonstrated knowledge of data warehousing concepts and methodologies, technologies, and tools
Experience working with AzureSQL and Azure Data Factory data pipelines highly desired
Experience building Power BI dashboards strongly preferred
Demonstrated ability to understand, discuss and document complex data models
Excellent communications skills, both, written and oral
Ability to manage and complete multiple concurrent projects in a timely manner
Excellent problem solving and analytical skills
PREFERRED EXPERIENCE
Experience working with Azure DevOps
Experience with cloud data warehousing and tools like Snowflake and dbt highly desired
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Sr. Database Engineer?
Sign up to receive alerts about other jobs on the Sr. Database Engineer career path by checking the boxes next to the positions that interest you.