Role Description The Applications Development Senior Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming activities. - Conduct tasks related to feasibility studies, time and cost estimates, IT planning, risk technology, applications development, model development, and establish and implement new or revised applications systems and programs to meet specific business needs or user areas. - Monitor and control all phases of development process and analysis, design, construction, testing, and implementation as well as provide user and operational support on applications to business users. - Utilize in-depth specialty knowledge of applications development to analyze complex problems/issues, provide evaluation of business process, system process, and industry standards, and make evaluative judgement. - Recommend and develop security measures in post implementation analysis of business usage to ensure successful system design and functionality. - Consult with users/clients and other technology groups on issues, recommend advanced programming solutions, and install and assist customer exposure systems. - Ensure essential procedures are followed and help define operating standards and processes. - Serve as advisor or coach to new or lower level analysts. - Has the ability to operate with a limited level of direct supervision. - Can exercise independence of judgement and autonomy. - Acts as SME to senior stakeholders and/or other team members. - Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency. Qualifications - 5-8 years of relevant experience. - Experience in systems analysis and programming of software applications. - Experience in managing and implementing successful projects. - Working knowledge of consulting/project management techniques/methods. - Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements. Requirements - Bachelor’s degree/University degree or equivalent experience. Company Description Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law. If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi. View Citi’s EEO Policy Statement and the Know Your Rights poster.

Role Description Join Ferguson’s Decision Support Center (DSC) and help shape how we deliver data-driven insights and process improvements across the enterprise. This role will focus on designing advanced data solutions, building impactful analytics, and driving operational efficiency through insightful reporting. - Design, develop, and deploy advanced Power BI dashboards, reports, and scorecards with high business impact. - Write and optimize complex SQL queries to extract, transform, and prepare data from different sources for analysis. - Integrate data from various sources, including Azure Synapse, SharePoint, SQL databases, and Databricks to power analytics solutions. - Collaborate with business partners to gather and understand data needs, particularly in operational contexts. - Apply advanced DAX to create dynamic calculations, critical metrics, and measures within Power BI. - Serve as a key partner in business analysis to translate operational needs into technical reporting solutions. - Proactively find opportunities to streamline processes and improve data visibility for Field Purchasing and other key business units. - Provide technical guidance and mentorship to junior developers and share knowledge across the team. - Manage multiple project timelines and priorities independently, ensuring alignment with business objectives. - Communicate clearly with both technical teams and non-technical partners to ensure alignment and clarity. - Apply Lean thinking principles to identify inefficiencies and propose practical, data-informed improvements. - Troubleshoot and performance-tune Power BI solutions for scalability and responsiveness. - Leverage AI and machine learning capabilities to enhance analytics solutions, including: - Integrating predictive models and forecasting into reporting. - Using AI-assisted tools to accelerate development and improve code quality (e.g., Copilot, automated code generation). - Identifying opportunities to embed AI-driven insights directly into dashboards and business workflows. Qualifications - Bachelor’s degree in Business Administration, Computer Science, Information Technology, or a related field; or equivalent experience preferred. - 6+ years of hands-on experience developing and deploying Power BI solutions with deep knowledge of DAX and SQL. - Solid background in working with operational data and a preference for candidates who have supported Field Purchasing teams or functions. - Experience with data integration across multiple sources including cloud-based databases. - Demonstrated ability to solve problems independently and creatively in complex data environments. - Strong project and time management skills, with the ability to balance multiple priorities in a fast-paced setting. - Excellent communication and interpersonal skills, with comfort interacting across business and technical teams. - Leverage artificial intelligence (AI) capabilities to enhance analytics solutions, including: - Integrating predictive models and forecasting into reporting. - Using AI-assisted tools to accelerate development and improve code quality (e.g., Copilot, Gemini, automated code generation). - Finding opportunities to embed AI-driven insights directly into dashboards and business workflows. - Familiarity with Lean or continuous improvement methodologies is highly desirable. - Self-starter with a passion for continuous learning and a focus on delivering real-world results. Benefits - Health, dental, and vision insurance. - Paid time off. - Life insurance. - 401(k) with a company match. - Mental health coverage. - Gender affirming and family building benefits. - Paid parental leave. - Associate discounts. - Community involvement opportunities. Pay Range Actual pay rate may vary depending upon location. The estimated pay range for this position is below. The specific rate will depend on a candidate’s qualifications and prior experience. - $6,000.30 - $13,016.30 (Estimated Ranges displayed are Monthly for Salaried roles or Hourly for all other roles). - This role is Bonus or Incentive Plan eligible. - The Company complies with all wage regulations. The starting wage may be higher in certain locations based on local or state wage requirements. Equal Employment Opportunity The Company is an equal opportunity employer as well as a government contractor that shall abide by the requirements of 41 CFR 60-300.5(a), which prohibits discrimination against qualified protected Veterans and the requirements of 41 CFR 60-741.5(A), which prohibits discrimination against qualified individuals on the basis of disability. Ferguson Enterprises, LLC. is an equal employment employer F/M/Disability/Vet/Sexual Orientation/Gender Identity.

• Gather detailed requirements from business teams for new business intelligence and reporting initiatives • Document requirements and translate them into user stories for the development team • Design and develop data models to support the reporting and analytics needs of the business • Work closely with data engineers and developers to ensure the successful delivery of BI solutions • Test and validate BI deliverables to ensure they meet the defined requirements and provide the expected value • Coordinate with business stakeholders to gather feedback, address issues, and manage ongoing support • Demonstrate excellent attention to detail and strong problem-solving skills to identify and resolve data quality issues • Maintain clear and concise communication with all project team members and stakeholders • Continuously learn and stay up-to-date with the latest BI tools, technologies, and best practices

Role Description Science Systems and Applications, Inc. (SSAI) is seeking a senior BI Developer / Data Engineering professional to support enterprise data initiatives for a public sector education client. The selected candidate will design, automate, support, and improve data extraction, transformation, loading, data warehouse, and data lake solutions. This position is Onshore / Remote and requires availability during Pacific Time business hours. This role is ideal for a senior data professional with deep experience in: - Oracle - dbt - ETL/ELT - Data ingestion - Dimensional modeling - Cloud data integration - Data quality validation - Git/CI-CD deployment practices The work supports large-scale enterprise data management and reporting needs across business customers, vendors, and internal technical teams. Key Responsibilities: - Design, automate, support, and enhance sophisticated data extraction, transformation, and loading applications. - Develop and support Oracle database batch applications within data warehouse and data lake environments. - Ingest data from heterogeneous sources into on-premises or cloud data storage platforms, including environments such as Snowflake, AWS, and related cloud data services. - Build and manage ETL/ELT workflows using dbt, Oracle Data Integrator (ODI), Oracle PL/SQL, Oracle SQL, and shell scripting. - Develop dimensional hierarchies and data models to support enterprise data management reports and analytics needs. - Create and improve data solutions that support smooth, reliable data delivery across large volumes of data. - Perform data quality validation, write dbt tests, and help resolve data integrity or reporting issues. - Support API development frameworks and cloud-native data integration technologies as needed. - Support data lake migration from on-premises systems to cloud platforms. - Build incremental models, manage raw data layers, and develop modular dbt models for vendor/application data. - Convert complex Oracle stored procedures into maintainable dbt models using macros, hooks, incremental models, and modular design practices. - Use Git workflows, branching strategies, and CI/CD pipelines to support automated deployment of data solutions. - Collaborate with business customers, vendors, and internal resources to clarify requirements, resolve issues, and support successful delivery. - Provide weekly status updates and maintain required project/time reporting. Qualifications - 10+ years of demonstrated experience in BI development, data engineering, ETL/ELT, data warehouse, data lake, enterprise data management, or closely related services. - Strong knowledge of Oracle database development for batch applications in data warehouse or data lake environments. - Hands-on experience with data ingestion from multiple heterogeneous sources into on-premises and/or cloud data platforms. - Experience using dbt, ODI, Oracle PL/SQL, Oracle SQL, and shell scripting to manage ETL/ELT processes. - Experience developing dimensional hierarchies and data models for enterprise reporting. - Experience creating, maintaining, processing, and analyzing large data volumes. - Experience with data quality validation, reconciliation, and testing. - Knowledge or hands-on experience with API development frameworks. - Knowledge or hands-on experience with cloud-native data integration technologies. - Experience supporting data lake migration from on-premises systems to cloud platforms. - 3+ years of experience building incremental models, handling raw data layers, and building dbt models for vendor/application data. - Proficiency in dbt development, including macros, hooks, incremental models, data quality tests, and model security. - Experience converting complex Oracle stored procedures into modular dbt models. - Expert-level knowledge of Git workflows, branching strategies, and CI/CD pipelines for automated deployment. - Strong communication skills and ability to work with business stakeholders, vendors, and technical teams. Desired Qualifications - Previous experience working on LAUSD Data Lake systems or similar large education/public-sector data platforms. - Hands-on experience with Snowflake, AWS, or other cloud data platforms. - Experience with Oracle Data Integrator (ODI) in enterprise environments. - Experience modernizing legacy Oracle/PL SQL data processes into dbt-based models. - Experience supporting cloud data migration, data validation, and data reconciliation activities. - Experience working with vendor/application datasets and enterprise reporting requirements. - Strong technical problem solver with deep Oracle, dbt, ETL/ELT, data warehouse, and data lake experience. - Experience in Agile, DevOps, or CI/CD-enabled data delivery environments. Physical Requirements - Regularly required to stand, walk, and use hands to touch, handle or feel objects, tools or controls. - Frequently required to talk and hear. - Occasionally required to reach with hands and arms and stoop, kneel, crouch, or crawl. - Must regularly lift and/or move up to 10 pounds, and occasionally lift and/or move up to 25 pounds. - Specific vision abilities required include close vision, peripheral vision, depth perception, and the ability to adjust focus.