Eagle Creek Software Services Data Warehouse Developer in Burlington, Massachusetts
Our Customer Data Platform team is a highly strategic and Digital information technology focused team responsible for leading our digital 1st party data collection. This initiative, spanning digital marketing and advertising functions within business units, enables customer driven use cases across digital customer journey and engagement. Within these consumer engagements, our data collection processes provide a base foundation for deep analytics and data science. Under the direction of an assigned supervisor, the Data Warehouse developer will perform design, development, implementation, maintenance and enhancement related activities necessary to support data warehousing, business intelligence and reporting systems.
The ideal candidate will have the opportunity to demonstrate data warehouse and data mart expertise.. The role requires experience with Microsoft BI tools, MS Azure, data warehouse architecture and data modeling. Specifically, the Data Warehouse Developer:
Captures requirements and developing new database models/designs within our data warehouse platform
Designing and developing working data mart prototypes to meet reporting performance measures as well as working with the BI Development team to drive reporting and dashboard development based on multiple data sources to answer key business questions.
Working with digital insight analysts and business stakeholders to understand business/organizational questions being asked and determining existing and new BI models to support the requests.
Determining Scope, levels of effort and time necessary to develop, test and deploying working models
The role will work within our customer data platform team and digital direct teams to capture and expand our insight and analysis capabilities for our digital businesses. The role requires a self-starter and someone who thrives on implementing creative approaches and challenges. Moreover, challenging themselves and others to constantly come up with better solutions and improvements in expanding our insight capabilities.
ESSENTIAL DUTIES AND RESPONSIBILITIES:
Develop an in-depth understanding of data maintained in various transactional systems and how data from these systems are best organized and integrated to support transactional, reporting, and analytic needs.
Create and maintain relational and dimensional data structures to meet functional requirements and optimize performance.
Develop and maintain data marts, data cubes, queries, and reports
Develop and maintain data models and data maps for data warehouse system and operational data store.
Creating star schema data models, performing ETLs and validating results with business analysts and business partners
Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.
Develop and prepare schedules for new data marts.
Analyze large databases and recommend appropriate optimization for same.
Design data models and define both logical and physical models.
Administer requirements and design various functional specifications for data.
Prepare ad hoc queries reports for both technical and business teams.
Prepare various code designs and ensure efficient implementation of same.
Evaluate all codes and ensure quality of all project deliverables.
Provide support to teams in all technical matters.
Design and implement various unit tests on system and prepare test data.
Data Warehouse and Data Mart concepts, structures and systems
Extract, Transform and Load processes
Reporting design and delivering reporting solutions
Relational database concepts
Microsoft SQL Server Database
End-user reporting tools
Windows and Unix operating systems
Basic statistical methods
The ability to understand complex data models
Develop SQL statements, procedures and functions
Debug and solve problems
Manage multiple priorities, follow project plans and meet project deliverables
Complete assignments on time
Learn new skills and adapt to changes in technology
Strong interpersonal and communication skills
Analytical problem-solving skills
Institute data quality measures and to validate data between source and target systems
Prior experience working with Digital marketing/eComm/Consumer Direct is a plus
Bachelor’s Degree in Business, Information Technology, an Analytics related degree, or equivalent work experience
3-5 years of proven SQL Server Experience building and supporting Data Warehouse and Data Mart structures. Support end user reporting tools such as Microsoft SQL Server Reporting Services and Power BI.
Preferred - Microsoft Technology Associate (MTA), Microsoft Certified Solution Associate (MCSA), Microsoft Certified Solutions Developer
Experience with Azure SQL products and services highly desire
Exposure to Big Data Technologies such as Hadoop, MapReduce, Spark or other Big Data Platforms is a plus
Experience with eComm, digital analytics and marketing data integrations desired
Ability to think creatively and solve problems
Mentor /guide and train junior team members
Tracking Code: 2116-506
Job Location: Burlington, Massachusetts, United States
Position Type: Full-Time/Regular