Power BI SQL Developer

Job Posting: Senior SQL and Power BI Developer Location: Remote Position Description 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. Skills Required

• Knowledge and experience in applications software development principles and methods sufficient to participate in the design, development, testing and implementation of new or modified applications software.
• Operating systems installation and configuration procedures.
• Organization’s operational environment.
• Software design principles, methods and approaches.
• Principles, methods and procedures for designing, developing, optimizing and integrating new and/or reusable systems components.
• Pertinent government regulations.
• Infrastructure requirements, such as bandwidth and server sizing.
• Database management principles and methodologies, including data structures, data modeling, data warehousing and transaction processing.
• Functionality and operability of the current operating environment.
• Systems engineering concepts and factors such as structured design, supportability, survivability, reliability, scalability and maintainability.
• Optimization concepts and methods.
• Establish and maintain cooperative working relationships.
• Speak and write effectively and prepare effective reports.

Skills Preferred

• Possess advanced knowledge of SQL, encompassing intricate query optimization techniques, nuanced data manipulation strategies, and fine-tuning database performance.
• Expertise working with Oracle, MySQL, SQL Server, and Azure SQL.
• Strong understanding and extensive experience in Oracle PL/SQL programming, including stored procedures, triggers, and functions.
• Ability to design efficient data models for optimal storage and retrieval.
• Understanding of ETL processes and tools and scripting languages like Python, Perl, or Shell scripting.
• Ability to optimize queries and database structures.
• Knowledge of data warehousing concepts and tools.
• Proficiency with Power BI for visualizations and reports.
• Experience using version control systems like Git.

Experience Required

• Minimum of seven (7) years of experience in electronic data processing systems study, design, and programming.
• At least four (4) years in a lead capacity.

Experience Preferred

• 4 years in the past 7 years writing complex SQL queries and optimizing database performance across Oracle, MySQL, SQL Server, and Azure SQL.
• 3 years in the past 4 years with Oracle PL/SQL or similar procedural languages.
• 3 years in the past 4 years designing and optimizing database schemas.
• 3 years in the past 4 years developing reports and visualizations using Cognos, Power BI, or Crystal Reports.
• 3 years in the past 4 years implementing ETL processes.
• 3 years in the past 4 years providing technical leadership to junior developers.
• 2 years in the past 4 years communicating technical concepts to stakeholders.
• 3 years in the past 4 years troubleshooting complex database issues.
• 2 years building Power BI reports.
• 2 years in the past 4 years maintaining documentation of schemas, stored procedures, and ETL processes.

Education Required

• Bachelor’s degree in an IT-related or Engineering field.
• Additional qualifying experience may substitute on a year-for-year basis.

Education Preferred

• Bachelors in computer science, data analytics, or a related field.

Job Type: Contract Pay: $40.00 - $50.00 per hour Application Question(s):

• Which employment type do you prefer for your submission? - C2C, W2 or 1099?

Work Location: Remote Apply tot his job Apply To this Job