6 M Query Jobs

About ACA: ACA was founded in 2002 by four former SEC regulators and one former state regulator. The founders recognized the necessity for investment advisers to receive expert guidance on existing and new regulations. Over time, ACA has experienced organic growth and expansion through acquisitions to enhance our GRC business and technology solutions. Our array of services now includes GIPS standards verification, cybersecurity and technology risk, regulatory technology, ESG advisory, AML and financial crimes, financial and regulatory reporting, and Mirabella for establishing EU operations. Position Summary: As an Enterprise Data Manager at ACA, your role involves overseeing the development and utilization of data systems. You will be tasked with finding effective ways to organize, store, and analyze data while prioritizing security and confidentiality. Your strategic planning and supervision will be instrumental in enhancing our operational efficiency and driving business growth in a data-driven environment. Job Duties: - Develop and execute data management strategies aligned with company objectives. - Supervise the collection, storage, management, quality, and security of data. - Ensure data accuracy, accessibility, and minimize redundancy. - Collaborate with IT teams and management to formulate a data strategy meeting industry requirements. - Lead and mentor a team of data professionals. - Contribute to the design and development of the core Enterprise Data Services hub. - Engage directly with internal business stakeholders to elicit requirements and align on solution options. Education, Experience, and Skills: - Bachelor's degree in Computer Science, Data Science, or related field with a minimum of seven (7) years of experience OR a minimum of ten (10) years of relevant industry experience (in the absence of a bachelor's degree). - Proficiency in data modeling practices with a background in building enterprise data solutions. - Experience in designing and constructing reporting and dashboarding solutions. - Familiarity with Microsoft Azure cloud environment and relevant data technologies such as Azure Data Factory, Event Hubs, Synapse, etc. - Eagerness to learn and experiment with new technologies to deliver top-notch solutions. - Strong communication skills to articulate technical topics to business stakeholders. - Experience in extracting and pushing data from diverse APIs, including REST. - Proficiency in utilizing Postman. - Ability to read and write SQL, stored procedures, and functions. - Demonstrated knowledge and experience with Azure Data Factory pipelines. - Proficiency in Azure data landscape. - Familiarity with DAX and M query formations. Preferred Education and Experience: - Hands-on experience with Power BI. - Experience in building SSAS cubes, particularly in tabular modeling. - Knowledge of C#, Python, or other object-oriented programming languages is a plus, currently utilized for writing Azure Functions as required. - Understanding of AI/ML to support long-term strategy. Required Skills and Attributes: - Proficient in Data Modeling. - Hands-on experience with Azure Cloud and pertinent data technologies. - Adept at building reports and dashboards, preferably using Power BI. - Ability to collaborate effectively with all levels of leadership and business partners. - Capable of managing multiple projects simultaneously and adapting swiftly to changing business needs. Why join our team Joining ACA means becoming part of the premier governance, risk, and compliance (GRC) advisor in financial services. Our team comprises former regulators, compliance professionals, legal experts, GIPS standards verifiers, cybersecurity specialists, ESG advisors, and regulatory technology practitioners. We foster an entrepreneurial work environment by providing innovative solutions tailored to our clients" needs. At ACA, we value creative thinking, offer diverse career paths, and emphasize continuous learning through inquiry, curiosity, and transparency. If you are ready to be a part of an award-winning, global team of dedicated and skilled professionals, ACA is the ideal place for you.,

As an Enterprise Architect at ACA, your primary responsibility will be to oversee the development and utilization of data systems. You will play a crucial role in discovering efficient methods to organize, store, and analyze data while ensuring its security and confidentiality. Your strategic planning and oversight will be instrumental in enhancing operational efficiency and driving business growth for a data-driven company like ACA. Key Responsibilities: - Develop and implement data management strategies aligned with company objectives. - Supervise the collection, storage, management, quality, and security of data. - Ensure data accuracy, accessibility, and minimize redundancy. - Collaborate with IT teams and management to devise a data strategy meeting industry standards. - Lead and mentor a team of data professionals. - Contribute to the design and development of the core Enterprise Data Services hub. - Engage directly with internal business stakeholders to elicit requirements and align on solution options. Education, Experience, and Skills: - Bachelor's degree in Computer Science, Data Science, or related field with a minimum of seven (7) years of experience OR at least ten (10) years of relevant industry experience (without a bachelor's degree). - Proficiency in data modeling practices with experience in building enterprise data solutions. - Hands-on experience in designing and constructing reporting and dashboarding solutions. - Familiarity with Microsoft Azure cloud environment and relevant data technologies like Azure Data Factory, Event Hubs, Synapse, etc. - Willingness to explore and adopt new technologies for delivering top-notch solutions. - Strong communication skills to effectively discuss technical matters with business stakeholders. - Experience in extracting and pushing data from various APIs, including REST. - Proficiency in using Postman, SQL, stored procedures, and functions. - Demonstrated expertise in Azure Data Factory pipelines and the Azure data landscape. - Knowledge of DAX and M query formations. Preferred Qualifications: - Prior experience with Power BI. - Proficiency in building SSAS cubes, particularly tabular modeling. - Working knowledge of C#, Python, or other object-oriented programming languages for Azure Functions. - Understanding of AI/ML to support long-term strategy. Required Skills and Attributes: - Proficient in Data Modeling. - Hands-on experience with Azure Cloud and relevant data technologies. - Experience in developing reports and dashboards, preferably using Power BI. - Ability to collaborate effectively with all levels of leadership and business partners. - Comfortable managing multiple projects simultaneously and adaptable to changing business needs. Preferred Licenses and Certifications: - Microsoft Certification in Azure or equivalent. - Certifications in Data Science. - Data Management Certification. Join us at ACA, the leading governance, risk, and compliance (GRC) advisor in financial services, where you will be part of a diverse team of industry experts. We offer an entrepreneurial work environment, innovative solutions, and multiple career paths for personal and professional growth. Embrace continuous learning, transparency, and join our award-winning global team of dedicated professionals at ACA.,

Job Title: Data Analyst Power BI & Python (with Data Quality & Storytelling Expertise) Experience: 3 to 6 Years Location: Chennai / Hybrid Employment Type: Full-Time Role: Data Analyst / Business Intelligence Specialist Job Description: We are looking for a highly motivated and skilled Data Analyst with hands-on experience in Power BI, Python, and SQL . The ideal candidate should be proficient in data storytelling, capable of identifying functional/data gaps, and transforming raw data into actionable insights for stakeholders across business and technology. Key Responsibilities: Analyze large datasets to identify data quality issues and functional gaps Conduct discussions with stakeholders to present insights and gaps effectively Leverage Power BI to build intuitive dashboards and create visual data narratives Use Python for data preparation and transformation supporting Power BI models Work closely with business/data providers to guide correct dataset sourcing Develop test cases and record them in test management platforms as required Prepare status reports and contribute to project documentation, KT, and team backups Required Technical Skills: Skill AreaTools / TechnologiesBI & DashboardsPower BI (Power Query, DAX, M Query)Data AnalysisPython (Pandas, NumPy), SQLData ModellingRelational models, ETL pipelinesVisualizationData storytelling with charts, graphsAgile PracticesDaily reporting, cross-functional collaborationBonus SkillsPrompt Engineering / Gen AI awareness Behavioral & Transversal Competencies: Strong communication (oral & written) Creativity and analytical problem solving Results-driven and self-managed attitude Strong collaboration and teamwork spirit Comfortable managing meetings, KPIs, documentation Educational Qualification: Bachelors degree in Computer Applications / Engineering / MCA Minimum 3 years of relevant experience in Data Analysis & BI Reporting If anyone interested please share your updated resume below Email muthukrishnan.saminathan@kiya.ai 6369929072

Greetings from INTELIZIGN! We have opening for power apps developer Work experience: 2+ years Work Place: Chennai Relevant exp: Power apps, Power BI, Power Automate Power BI Designed and developed interactive Power BI dashboards, providing real-time insights for Planning and Budget team of R&D Department Developed complex DAX and M Query calculations to optimize performance and improve reporting accuracy. Implemented role-based security in Power BI, ensuring controlled data access for different user levels. Migrated Excel-based and Power point-based reports to Power BI, enhancing data accuracy and visualization. Power Apps Created custom Power Apps applications like Task Management Tool, Time Sheet Tool and Travel request Tool to digitize manual processes, improving efficiency by 100%. Integrated Power Apps with SharePoint to streamline data entry and retrieval. Integrated Power Apps with Power BI, allowing users to take direct action on data insights Power Automate Flow Automated business workflows using Power Automate, reducing manual efforts by 8-10 hours per week. Automated email notifications, approvals, and data synchronization using Power Automate. Implemented data validation and transformation using expressions and conditions in Power Automate flows.

The IT Technical Analyst - Senior provides technical expertise in applications or infrastructure, delivering detailed solution designs that translate business requirements into scalable IT solutions. This role supports the design, development, implementation, and maintenance of IT systems and infrastructure in alignment with Cummins architectural standards and security practices. The position involves technical analysis, design review, solution configuration, and cross-functional collaboration to deliver optimized and reliable solutions. Key Responsibilities Develop and manage technical specifications to guide application, infrastructure, or solution development. Analyze and evaluate solution options, including commercial-off-the-shelf products vs custom-built solutions. Deliver and document detailed solution designs that meet business, performance, security, scalability, and maintainability requirements. Collaborate with infrastructure teams and service providers to ensure solution delivery meets specifications and quality standards. Participate in design and code reviews to ensure adherence to standards and requirements. Drive reuse of components and efficiency in the build and deployment processes using automation and CI/CD pipelines. Support the creation of runbooks and documentation for end-user support and knowledge transfer. Assist in testing strategy and execution of test plans for solution validation. Provide advanced (Level 3) support for critical technical issues and participate in system remediation. Analyze existing systems for improvements, optimizations, or compliance needs. Qualifications College, university, or equivalent degree in Computer Science, Information Technology, Business, or a related field is required. Relevant industry certifications are a plus. May require licensing for compliance with export controls or sanctions regulations. Experience 8-10 years of relevant technical experience in IT solution development and infrastructure design. Intermediate level of experience with demonstrated ability to design, implement, and support enterprise-level solutions. Skills and Experience Strong proficiency in: SQL, DAX, M Query, Python SSIS, SSAS, Azure DataLake, Databricks Power BI service development and optimization CI/CD pipelines (GitHub) Agile tools (Jira, Confluence) Familiarity with: C#, R, TensorFlow, PyTorch, NumPy Azure Analytics Services (AAS) Experience in: Data pipeline design and optimization AI/ML model integration and LLM training within Databricks Data governance and data quality metrics Cybersecurity and secure solution design Technical documentation and stakeholder communication Advanced data modeling in SSAS, Azure, Databricks Competencies Customer Focus - Builds strong relationships and delivers customer-centric solutions. Global Perspective - Approaches issues with a global lens. Manages Complexity - Resolves complex and sometimes contradictory data-driven problems. Manages Conflict - Handles challenging interpersonal situations effectively. Optimizes Work Processes - Continuously improves efficiency and effectiveness of processes. Solution Configuration & Design - Creates, configures, and validates COTS and custom-built solutions using industry-standard tools and practices. Performance Tuning - Optimizes systems and applications for maximum performance and scalability. Solution Validation Testing - Ensures solutions meet business and technical requirements through structured testing. Values Differences - Recognizes and leverages diverse perspectives and backgrounds.

Preferred candidate profile Strong knowledge and experience with the Power BI ecosystem (Power BI Desktop, Power Query, DAX, Power BI Service, etc) Should be able to propose and Design the high performing Power BI data models to cater to various functional areas of client. Should be able to design and develop detailed Power BI reports, and use various visualizations to develop summary and detailed reports. Should be very good with DAX functions and could create complex DAX queries, and M Query. Should be able to provide quick solutions to the issues raised by business users. Should have proven capability in using various Power BI features like bookmarks, Drill through, query merge etc 4+ years of experience in data analysis developing business intelligence and reporting in a medium to large size corporate environment demonstrating detailed knowledge of BI functions such as analytics, data modeling & data mining, reporting, report conversion and data cleansing. Strong knowledge and experience in analyzing and designing data models to meet reporting requirements Experience designing and developing visually engaging and informative dashboards and KPIs (Key Performance Indicators) using Power BI, MS SSRS Experience with Microsoft Azure data analytics tools, such as Azure Data Factory, Azure Synapse, Azure Data Lake, DevOps Should be able to understand and document the requirements from business users. Should be able to optimize large datasets and reports built on top of Oracle Database. Should be able to suggest architectural changes to client to reduce the load on Power BI service. Should be aware of Power BI licensing mechanism and should be able to figure out optimal licensing strategy to reduce the cost for client. Should be good with Oracle queries and should be able to suggest database table optimizations for faster retrieval of records. Knowledge of Tableau will be an added advantage. Knowledge of the ETL process (informatica will be added advantage). Knowledge of SAP BW will be added advantage.