Mid Data Solutions Analyst
Job description
About the role
This position involves developing and maintaining data solutions to ensure high standards of data quality across the organization. You will leverage diverse data technologies to construct and refine data pipelines and reporting systems that serve critical business functions. The role is centered on delivering robust and reliable data infrastructure that directly supports business intelligence and advanced analytics initiatives. You will own the end to end lifecycle of data solutions from initial requirements gathering through deployment and ongoing optimization. This position requires close collaboration with both technical and non technical stakeholders to align data capabilities with strategic business objectives. You will be responsible for translating complex data concepts into clear narratives that drive informed decision making across the company. The work involves constant evaluation of data processes to identify inefficiencies and implement improvements that enhance scalability and performance. You will act as a key custodian of data integrity ensuring that the information used for analysis remains accurate and trustworthy.
Key facts
What youll do
- Design and implement scalable data pipelines and ETL processes that automate the flow of information between source systems and analytical platforms.
- Conduct thorough data profiling and validation to ensure the accuracy, consistency, and integrity of data across all connected systems and databases.
- Partner with business stakeholders to gather data requirements and translate those needs into technical specifications and executable solutions.
- Architect and optimize data models that support complex reporting and analytical queries while balancing performance and maintainability.
- Establish and monitor data quality metrics and dashboards to proactively identify anomalies, outliers, and potential failures in the data ecosystem.
- Troubleshoot intricate data issues by diagnosing root causes and coordinating with cross functional teams to resolve problems efficiently.
- Implement and enforce data governance frameworks and security protocols to protect sensitive information and comply with regulatory standards.
- Create comprehensive technical documentation including data dictionaries, process flows, and operational runbooks to support knowledge transfer and continuity.
- Collaborate with data engineering and analytics teams to integrate new data sources and standardize data definitions across the enterprise.
- Optimize the performance of existing data workflows by refactoring queries, adjusting pipeline configurations, and leveraging best practices in data processing.
- Mentor junior analysts and data specialists on data handling techniques, tool usage, and adherence to organizational data standards.
- Participate in on call rotations to provide timely support for production data issues as they arise during business operations.
- Evaluate emerging data tools and technologies to recommend improvements that align with the strategic goals of the data platform.
- Ensure all data solutions are delivered on schedule and meet the agreed upon specifications and quality benchmarks.
Requirements
- Demonstrate substantial experience with SQL and relational databases including writing complex queries, joins, and optimization techniques.
- Show familiarity with major cloud data platforms such as AWS, Azure, or GCP and their respective data services and storage solutions.
- Possess a solid understanding of data warehousing concepts including dimensional modeling, fact and dimension tables, and grain definition.
- Exhibit the ability to work independently on assigned tasks while also contributing effectively within a collaborative team environment.
- Apply strong problem solving and analytical skills to deconstruct complex business problems into data driven insights.
- Maintain a high level of attention to detail to ensure that data transformations and pipelines produce accurate and reliable outputs.
- Communicate technical ideas clearly and concisely to both technical colleagues and business stakeholders without relying on excessive jargon.
- Commit to adhering to company policies, data security guidelines, and professional standards in all data handling activities.
Nice to have
Preferred skills and tools specific to the role will be outlined if provided in the original source documentation.
Practical notes
The engagement for this position is Full-time, indicating a standard work schedule as defined by company policy. No specific hours, travel requirements, visa information, or application deadlines are detailed in the provided source material. All employment will be conducted in accordance with local regulations in Mexico where the position is based.