Key Responsibilities: Contribute to the creation of technical specifications for applications, infrastructure, or complete solutions. Assist in technical analysis of potential solutions, evaluating the technical fit and viability of commercial off-the-shelf products versus custom-built solutions. Deliver solution designs, adhering to standards and leveraging re-use of components. Create high-level and detailed designs of infrastructure or applications, interfaces, conversions, extensions, reports, and workflows while meeting architecture, security, performance, scalability, and maintainability requirements. Assist technical and infrastructure groups in understanding the solution design and specifications. Participate in formal design reviews and code reviews to ensure detailed design specifications are understood and coding standards are adhered to. Leverage re-usability of component designs to reduce costs and shorten time to deliver solutions. Ensure efficiency in the build and deploy processes, leveraging automation where possible. Assist in the test strategy and execution of the master test plan. Contribute to the creation of standards, processes, procedures, and guidelines for the IT design and development community, as well as work instructions or runbooks used for end-user support. Analyze and revise existing systems and documentation to identify remediation or improvements in the application or infrastructure solution. Provide level 3 support for critical issues. Work closely with IT technical service providers to ensure outsourced work packages are delivered to specifications, meeting key parameters of quality, schedule, cost, security, performance, and scalability. Skills and Experience Needed: 3-5 years of experience. Proficiency in SQL, DAX, M Query, and Python. Familiarity with C# and R (TensorFlow, PyTorch, and NumPy would be a plus). Experience with Azure and Databricks. Experience with data pipeline development, maintenance, and improvement with Azure DataLake. Experience with SSIS (SQL Server Integration Services), SSAS (SQL Server Analysis Services), and Power BI Service. Experience in developing, maintaining, optimizing, automating, and supporting Power BI reports. Experience in data mining, data auditing, and data insight generation. Understanding of AI (Artificial Intelligence)/ML (Machine Learning) concepts and tools in Databricks. Strong technical writing skills for documentation and communication. Knowledge of cybersecurity principles and practices. Knowledge in data governance and knowledgebase management techniques. Proficiency with Agile tools like Jira and Confluence for project management and collaboration. Proficiency in optimizing SSIS, SSAS, AAS (Azure Analytics Services), and Databricks workflows for performance of large datasets. Qualifications: College, university, or equivalent degree in Computer Science, Information Technology, Business, or related subject, or relevant equivalent experience required. This position may require licensing for compliance with export controls or sanctions regulations. Competencies: Collaborates: Building partnerships and working collaboratively with others to meet shared objectives. Customer Focus: Building strong customer relationships and delivering customer-centric solutions. Interpersonal Savvy: Relating openly and comfortably with diverse groups of people. Plans and Aligns: Planning and prioritizing work to meet commitments aligned with organizational goals. Tech Savvy: Anticipating and adopting innovations in business-building digital and technology applications. Solution Configuration: Configures, creates, and tests solutions for commercial off-the-shelf (COTS) applications using industry standards and tools, version control, and build and test automation to meet business, technical, security, governance, and compliance requirements. Solution Design: Creates and defines solution designs complete with instrumentation and measurement, using industry standards and tools, version control, and build and test automation to synthesize diagrams, models, and documentation to build solutions that meet buildability, business, technical, security, governance, and compliance requirements. Solution Functional Fit Analysis: Composes and decomposes systems into component parts using procedures, tools, and work aides to study how well the component parts were designed, purchased, and configured to interact holistically to meet business, technical, security, governance, and compliance requirements. Solution Modeling: Creates, designs, and formulates models, diagrams, and documentation using industry standards, tools, version control, and build and test automation to meet business, technical, security, governance, and compliance requirements. Solution Validation Testing: Validates configuration item changes or solutions using the Function's defined best practices, including the Systems Development Life Cycle (SDLC) standards, tools, and metrics, to ensure they work as designed and meet customer requirements. Values Differences: Recognizing the value that different perspectives and cultures bring to an organization.
