What are the responsibilities and job description for the Senior Data Engineer position at On-Demand Group?
Job Description
Title: Senior Data Engineer
Location: Hybrid or REMOTE for MN local candidates
Duration: Direct Hire
Job Description:
The Sr. Data Engineer will play a critical part within the Data Management and Reporting team in the support of enterprise business intelligence solutions. This individual will be involved in data warehouse development including requirements gathering, database modeling, ETL and dashboard/report development activities. The role will frequently conduct data analysis, write advanced database queries and create report solutions needed by business and/or executive operations. This person will enable daily business activities by providing the foundation of all federated querying and analysis produced by the Actuarial and Data Science teams.
KEY RESULT AREAS:
1. Develop and support enterprise data warehousing platform
2. Develop and maintain enterprise reports and analytics dashboards
3. Establish/maintain data Lakehouse, ETL and reporting and best practices
4. Detect and resolve production performance issues
Develop and maintain enterprise data warehousing platform
• Work with business users to establish data warehousing and data lake requirements
• Develop and maintain ETL to support the Data and Analytics reporting platform
• Create and maintain data models to support business teams and initiatives
• Development of SQL procedures, triggers, views, functions, and reports to support enhancement to critical SQL based business systems for existing systems
• Support Data warehouse
• Write ad-hoc data and report requests
• Maintain and support AWS S3 data lake used for analytics and enterprise data warehouse
• Participate peer code reviews, unit testing and documentation of code developed
Develop and maintain enterprise reports and analytics dashboards
• Analyze BI requirements and translate user requirements into actionable implementation details
• Develop and maintain business-oriented Power BI and SSRS dashboards/reports
• Compile ad-hoc data and report requests
• Participate peer code reviews, unit testing and documentation of code developed
Establish/maintain data Lakehouse, ETL, and reporting and best
• Perform and/or lead design, coding, testing, implementation, and documentation of solutions
• Contribute to, enforce, and document database policies, procedures and standards
• Provide technical and business knowledge support to the team
• Participate in data governance
• Perform tests and evaluations regularly to ensure data security, privacy and integrity
Detect and resolve production performance issues
• Performance tuning and database optimization
• Provide ongoing maintenance support through query tuning and optimization
• Analyze troubleshoot and remediate data integrity issues
How We Work
• Service – listen with compassion and empathy. Understanding before responding. Making time to care for our colleagues and customers and put our team and others before ourselves
• Integrity – work with honesty, transparency and authenticity. Working ethically in our actions and consistently treating others with respect and kindness. Being a good steward of company assets, expenses and time
• Teams – build connections across the organization. Nurturing close cross-functional relationships build on communication and trust. Working actively to understand relationships across the organization and are sensitive to the ripple effects of our actions
• Learning – seek to always learn. Seizing opportunities to broaden our knowledge. Seeking and providing honest feedback to support continual improvement
• Accountability – driven to act. Recognizing the power of goals to help us stay focused and used our collective energy for greatest impact. Respecting deadlines, honoring commitments, and delivery results for ourselves and our team
• Better Together – believe in the power of the many. Actively seeking out and embracing diverse perspectives and opinions. Acting courageously in disagreements and staying curious when others disagree with ourselves
Required Qualifications:
• 4 years BI Developer experience
• 1-3 years’ experience building and managing Data Lakes
• Strong knowledge of Cloud Database Management Systems
• Strong knowledge of Python
• Experience building ETL processes for data warehouse and reporting platform (MS SQL Server preferred)
• Solid understanding of relational database theory, principles, and best practices
• Must be a self-starter who requires minimal supervision, with excellent problem-solving skills
• Cloud experience required