Technical Manager - Data Services at Epson

Your mission:

• As the Technical Manager – Data Services, you will be a key member of our technical team, responsible for overseeing, designing, developing, implementing, maintaining and supporting Epson’s database solutions, leveraging SQL Server, Fabric, PowerApps and the Microsoft Power Platform. You will play a crucial role in delivering innovative applications and business process automation solutions that empower our organization to achieve its goals and drive efficiency.
• This role combines technical expertise with leadership responsibilities to ensure high availability, security, scalability, and efficient operation of database platforms.

What you will do:

Database Design and Management:

• Design, implement, and manage SQL Server databases to support business operations and applications.
• Develop database schemas, tables, views, stored procedures, and functions to meet business requirements.

Data Integration and ETL:

• Implement ETL processes to integrate data from multiple sources into SQL Server databases.
• Develop data migration scripts and workflows to facilitate seamless data transfer and transformation.

PowerApps Development:

• Design and develop PowerApps applications to automate business processes, streamline workflows, and improve productivity.
• Customize and extend PowerApps using Power Platform connectors, formulas, and expressions.

Power Platform Solutions:

• Utilize the Microsoft Power Platform (Power BI, Power Automate, Power Virtual Agents) to build end-to-end solutions that leverage data analytics, automation, and AI-driven insights.
• Integrate Power Platform solutions with existing systems and applications to enhance functionality and usability.

Application Development and Customization:

• Develop custom solutions and applications using Microsoft technologies, including .NET, C#, and JavaScript.
• Customize and extend existing applications, interfaces, and workflows to meet evolving business needs.

Quality Assurance and Testing:

• Conduct thorough testing of SQL databases, PowerApps, and Power Platform solutions to ensure functionality, reliability, and performance.
• Identify and address defects, bugs, and performance issues through debugging and troubleshooting.

Documentation and Knowledge Sharing:

• Document technical specifications, system configurations, and development processes for internal reference and knowledge sharing.
• Provide training and support to team members on SQL, PowerApps, and Power Platform development best practices.

Semantic Model Development:

• Design, develop, and optimize Power BI semantic models, including data modeling, relationships, and DAX calculations, to ensure efficient and accurate data analysis. 

Data Pipeline Implementation:

• Build and maintain data pipelines using Microsoft Fabric, including Dataflows Gen2, Data Factory, and other relevant Fabric components, to ingest, transform, and load data into the semantic model. 

SQL Expertise:

• Utilize SQL for data querying, manipulation, and transformation within the Fabric environment, including working with SQL databases and Synapse Data Warehouse. 

Power BI Dashboard Development:

• Create interactive and visually appealing dashboards and reports using Power BI, incorporating data from the semantic model and other relevant sources. 

Collaboration and Communication:

• Collaborate with business stakeholders, data analysts, and other team members to gather requirements, communicate insights, and ensure the successful delivery of data solutions. 

Performance Optimization:

• Optimize the performance of Power BI reports, semantic models, and data pipelines to ensure efficient and scalable solutions. 

Data Governance and Security:

• Implement and maintain data governance and security practices to ensure data quality, integrity, and compliance. 

Cloud Platform Management:

• Manage and maintain the Fabric environment, including configuring compute, storage, and other resources, while also monitoring performance and troubleshooting issues. 

Staying Current:

• Keep up to date with the latest features and updates in Power BI, Fabric, and related technologies, and recommend best practices for their implementation.

What we ask for:

• Experience with SQL database management and support
• Experience of .NET programming language and Visual Studio
• Experience of data modelling with SQL Server, Query Analyzer, Enterprise Management Studio
• Previous participation in software projects and software solution implementations
• Understanding of business process modelling and analysis
• Understanding of software development methodologies (Agile and Waterfall)
• Understanding of IT project management standards (PMI / Prince2)
• Strong understanding of Power BI, including semantic model design, DAX, and data visualization best practices.
• Proficiency in SQL for data querying and manipulation.
• Experience with Microsoft Fabric, including Dataflows, Data Factory, and other relevant components.
• Familiarity with data warehousing concepts and architectures.
• Knowledge of data modeling techniques and best practices.
• Experience with data pipelines and ETL processes.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills.
• Experience with cloud platforms, particularly Azure, is a plus.