Senior SQL and Power BI Developer

$40 - $45/Yr

Varite - Downey, CA

- Senior

Downey, CA

Professional, Scientific, and Technical Services

About the position

A Senior Programmer is responsible for leading and/or working on the most complex IT applications design, documentation, development, modification, testing, installation, implementation and support of new or existing applications software. This classification may also plan, install, configure, test, implement and manage a systems environment in support of an organization's IT architecture and business needs. Common organizational or functional industry position titles for programmers include but are not limited to programmer analyst, applications developer, software engineer, software developer, software quality assurance specialist, systems programmer, systems software programmer, database administrators, computer systems analysts, systems engineer, systems software engineer. The Senior Programmer, in development of applications software, is responsible for analyzing and refining systems requirements; translating systems requirements into applications prototypes; planning and designing systems architecture; writing, debugging and maintaining code; determining and designing applications architecture; determining output media/formats; designing user interfaces; working with customers to test applications; assuring software and systems quality and functionality; integrating hardware and software components; writing and maintaining program documentation; evaluating new applications software technologies; and/or ensuring the rigorous application of information security/information assurance policies, principles and practices to the delivery of application software services. The Senior Programmer, in development of operating systems, is responsible for analyzing systems requirements in response to business requirements, risks and costs; evaluating, selecting, verifying and validating the systems software environment; evaluating, selecting and installing compilers, assemblers and utilities; integrating hardware and software components within the systems environment; monitoring and fine-tuning performance of the systems environment; evaluating new systems engineering technologies and their effect on the operating environment; and/or ensuring that information security/information assurance policies, principles and practices are an integral element of the operating environment.

Responsibilities

• Lead and work on complex IT applications design and development.
• Plan, install, configure, test, implement and manage systems environments.
• Analyze and refine systems requirements.
• Translate systems requirements into applications prototypes.
• Plan and design systems architecture.
• Write, debug and maintain code.
• Design user interfaces and work with customers to test applications.
• Assure software and systems quality and functionality.
• Integrate hardware and software components.
• Write and maintain program documentation.
• Evaluate new applications software technologies.
• Ensure application of information security/information assurance policies.

Requirements

• Minimum of seven (7) years of experience in electronic data processing systems study, design, and programming.
• At least four (4) years of experience in a lead capacity.
• Knowledge and experience in applications software development principles and methods.
• Experience with operating systems installation and configuration procedures.
• Understanding of software design principles and methods.
• Familiarity with database management principles and methodologies.

Nice-to-haves

• Strong understanding of relational database concepts, SQL, and data modeling.
• Proficiency in ETL tools like Azure Data Factory, Azure Synapse, or Microsoft SSIS.
• Ability to design and implement data warehouse data models.
• Knowledge of data integration techniques and data quality processes.
• Familiarity with data warehouse development methodologies.
• Proficiency in scripting languages like Python, Perl, or Shell scripting.
• Understanding of data security principles and compliance regulations.
• Skills in optimizing data warehouse performance.
• Ability to collaborate with business stakeholders for reporting requirements.