Job Description

Are you an experienced Sr. Data Engineer with a desire to excel? If so, then TALENT Software Services may have the job for you! Our client is seeking an experienced Sr. Data Engineer to work at their company in Wayne, PA.

Position Summary: We are seeking a skilled Sr Data Engineer to join our Commercial Team. In this role, you will collaborate with stakeholders to design, build, and maintain data infrastructure that supports the commercial team's efforts, enabling seamless data flow, analysis, and reporting. You will be responsible for integrating various data sources and building dashboards for high-performance analytics. The ideal candidate will have strong technical skills in data engineering, experience working with sales and marketing data, and a passion for creating data solutions that drive business decisions and growth.

Primary Responsibilities/Accountabilities:

Data Integration & Management

• Work closely with commercial teams to understand their data needs and integrate various data sources to create a unified view of revenue, order, pipeline, marketing lead, and customer data.
• Develop efficient data models that support business reporting and decision-making, using tools like SQL, Python, or R.
• Collaborate with data scientists and analysts to ensure data integrity, quality, and availability for advanced analytics and reporting.

Data Dictionary Development & Management

• Design, develop, and maintain a comprehensive commercial data dictionary including revenue, order and pipeline data from Snowflakes that defines all data elements, ensuring clear documentation for all stakeholders.
• Collaborate with business units, sales excellence and IT teams to gather detailed information on data sources, definitions, relationships, and usage.
• Ensure that the data dictionary is up-to-date and accessible, promoting standardization and consistency across the organization.
• Implement processes for ongoing management and updates to the data dictionary as data models and requirements evolve.

Power BI Data Model Design

• Build and optimize Power BI data models that support reporting and analytics requirements, ensuring that data is well-structured for efficient querying and analysis.
• Develop snowflake schema data models to support high-performance, scalable dashboards and reports in Power BI.
• Work closely with business analysts and end-users to translate business needs into technical data models and visualizations in Power BI.
• Create DAX measures and calculations to support complex reporting needs within Power BI dashboards.

Reporting & Visualization

• Support the development of Power BI dashboards by providing clean, structured data for visualizations.
• Assist the commercial team in building custom reports and dashboards by ensuring the data infrastructure supports their requirements.
• Enable real-time reporting by integrating live data feeds where applicable.

Data Infrastructure & Automation

• Build, maintain, and optimize scalable data pipelines to support automated data processing and real-time analytics.
• Work with IT and data engineering teams to ensure data is properly collected, stored, and accessible for analysis.
• Automate recurring tasks such as reporting, data extraction, and analysis to improve operational efficiency.
• Experience working with large datasets and creating data models to support business intelligence and analytics initiatives.

Qualifications:

• Bachelors or Masters degree in Computer Science, Data Engineering, Information Systems, or a related field.
• 3 years of experience in data engineering, with a strong focus on building data models and managing data dictionaries.
• Proven experience with Power BI, including building complex data models, optimizing performance, and creating dashboards with DAX/PowerQuery.
• Strong SQL skills for data querying and manipulation, with experience in database management and ETL processes.

Preferred:

• Expertise in statistical and mathematical methodologies for data analysis.
• Experience with CRM systems (e.g., Salesforce, C4C) and sales performance data.
• Exceptional project management and organizational skills.
• Effective communication skills, capable of conveying complex data insights to non-technical audiences.
• Proven ability to foster a collaborative team environment.
• Strategic thinking and proactive problem-solving abilities.

Job Tags

Similar Jobs